﻿CREATE TABLE [dbo].[Old_Admission] (
    [Admission_No]     NVARCHAR (50) NULL,
    [Class]            NVARCHAR (12) NULL,
    [Section]          NVARCHAR (10) NULL,
    [Admission_Code]   NVARCHAR (20) NULL,
    [st_Status]        NVARCHAR (20) NULL,
    [Student_Name]     NVARCHAR (35) NULL,
    [Father_Name]      NVARCHAR (30) NULL,
    [Mother_Name]      NVARCHAR (30) NULL,
    [Parent_Status]    NVARCHAR (10) NULL,
    [dob]              NVARCHAR (20) NULL,
    [Joined_date]      NVARCHAR (20) NULL,
    [Joined_class]     NVARCHAR (20) NULL,
    [Joined_section]   NVARCHAR (10) NULL,
    [Joined_Session]   NVARCHAR (10) NULL,
    [Transfer_session] SMALLINT      NULL,
    [Transfer_Date]    NVARCHAR (20) NULL,
    [House_Code]       NVARCHAR (10) NULL,
    [House_Name]       NVARCHAR (30) NULL,
    [Sex]              NVARCHAR (10) NULL,
    [Admission_Status] NVARCHAR (20) NULL,
    [BloodGroup]       NVARCHAR (50) NULL
);

